-
Re: How do I get the lines that are overdue to change color?
@Alicia.ferrari Click this button on the task bar. It's the conditional formatting button: Then click Add New Rule: Then you need to click each of these 3 underlined links starting from the left and …1 · -
Re: Moving completed rows onto an archive sheet automatically?
@SmartsheetRookie You can set up an automation such as: You can only move the row to another sheet. Automations cannot delete entire rows.1 · -
Re: Can a sheet report have a formula to filter data from a drop down?
Like this? Example Sheet: Primary Role formula: =PARENT(Role@row) Report:1 · -
Re: Browse Workspaces in the Sheet Picker for Copy/Move Row Automations
@Linda Hoydic I'm beginning to believe whatever database the search is querying isn't updated in real time but is updated on a cycle. Usually what I'm doing on my end is setting up an Archive sheet. …1 · -
Re: Browse Workspaces in the Sheet Picker for Copy/Move Row Automations
@Genevieve P. I spent 20 minutes trying to set up a Move Row automation today because it kept telling me the exact same search was not found for 20 minutes, until it finally was. Nobody seems happy w…3 ·